Mega Code Archive
MySQL Database
1) A couple of functions that convert an IP address into its color code
2) A database abstraction layer for the PHP 3.0 ODBC module
3) A database abstraction layer for the PHP Oracle 8 module
4) A function to open a connection to mysql
5) A login system that uses PostgreSQL
6) A set of functions sitting on top of the abstraction layer that makes it a little
7) A simple guestbook application demonstrating using MySQL and PHP3
8) A template script to provide the ability to get the next or previous n records
9) A very simple and efficient split bar the B-Z bar , for mysql and php
10) A very simple postgreSQL guestbook script
11) A very simple way to build and do a hierarchical html categories browser
12) A what happened on this day class
13) Accepts a database & hostname from a user and then HTTP username
14) Access sqlite database
15) Add record to my_databasemy_table
16) Add, Edit & Update All in one Contact Management Form
17) Adding a Row to a Table
18) Advanced Functions
19) An Example of Using the Old MySQL Extension
20) An SQL Administration User Interface for the Web
21) ASP(VBScript), from time to time, has some neat features. One is a function
22) Automatically printing the contents of an sql table in MySQL
23) Basic MySQL Example
24) Building dynamic menus with PHP & MySQL (ADO), JavaScript and CSS
25) Building Queries on the Fly
26) Calculating password length with DBM
27) Checks Date-Input from HTML-Forms and converts to YYYY-MM-DD
28) Close database connections
29) Color Selector Widget using PHP3 & MySQL
30) Complete, simple, working example of a login screen-system using php
31) Connect to MySQL
32) Connect To MySQL Database
33) Connecting to a MySQL Database
34) Connecting user
35) Copying Resultsets into an Array Manually
36) Count how many weeks in the month have a specified day
37) Create a grid out of INPUT TYPE=TEXT then saving to a database
38) Create an Array from SQL Result
39) Create Database
40) Create guestbook table
41) Create new table in MySQL
42) Create table and install data
43) Creating a Database in MySQL
44) Creating a Table in MySQL
45) Creating an SQLite database
46) Creating databases
47) Custom-error-messages php
48) Database and Recordset classes fo SyBASE Usage is obvious
49) Database Information
50) Databases administration remote Web
51) DB Connection Function with error handling and email failure notices
52) DB Field Finder
53) DB Operations - Handles almost all routine mysql queries
54) Delete data from database by ID
55) Delete data from database table
56) Deleting Data
57) Deleting databases
58) Disconnecting from a MySQL Database
59) Discovering Which Extension Is Being Used
60) Dynamic table columns
61) Dynamic WHERE CLAUSE depending on number of FORM FIELDS
62) Email a user with out exposing email address
63) Error Checking
64) Escape String
65) Example voting script. Lets people enter suggestions and vote for
66) Execute query with odbc_execute()
67) Fetch Associative Array
68) Finding the Number of Rows Returned by a SELECT Statement with mysql_num_rows()
69) Finds the median in an array of numbers - Can be used with a MySql
70) Fix to PHP4-MySQL problem
71) From result row get the table name
72) Function mysql_close() closes the connection
73) Function mysql_connect() establishes an initial connection with the MySQL server
74) Function mysql_fetch_array() accomplishes the same result as mysql_fetch_row(), by default it assigns a returned row to an
75) Function mysql_num_rows() determines the number of rows returned from a SELECT query statement
76) Function mysql_query() queries the database
77) Function mysql_result() produces a data set
78) Function odbc_exec() accomplishes the roles of both odbc_prepare() and odbc_execute()
79) Function Query2Array will read an PEAR-DB-Query-Result into an Array
80) Function to do live population of HTMLs Select tag from a Table
81) Get affected rows for an update
82) Get all tables in a database
83) Get column alias
84) Get column data type
85) Get column name, type and max length
86) Get data from database
87) Get data from database query
88) Get data from mysql
89) Get field length
90) Get MySQL client information
91) Get MySQL host information
92) Get MySQL server information
93) Get returned row count
94) Get table column flag
95) Google like search function with bolded search terms
96) Here is a quick n dirty image uploader to a mysql db
97) load a query result into a PHP Array
98) show images stored in a database
99) thread a list of messages in database and show it in a treelike structure
100) Html split bar used to split in multiple pages a database result
101) I can read real internet-pages on my Smartphone, I am now creating
102) I got tired of typing the connection code for MySQL on every PHP
103) I thought I would put in an example of the ORACLE BIND
104) I`d like to use the mysql_fetch_row function along with a randomizer
105) Identify and log search engine access (spiders, robots, etc.) to a page
106) In PHP 5 using the MySQLi extension
107) Initializing the MSQL-tables via a 2-dimens array
108) Insert data to mysql table
109) Int mysql_num_rows ( resource result )
110) Its been a long time sinse I did a Mssql manager so heres a standardised
111) Its easy to select multiple rows from a mySql Table
112) Just some real-life functions you can call to perform common datetime
113) Last Insert ID
114) Limit the display of records on each page from mysql
115) List all database
116) List all tables in a database
117) List Database, Table, and Field
118) List people whose birthdays fall on the current Day and Month
119) Listing All Rows and Fields in a Table
120) Listing databases
121) Listing Tables
122) Listing Tables in a Database
123) Listing the Databases Available in a Connection
124) Load delimited textfile into MySql table
125) Microsoft DAO 3.5 compliant data access to MySQL database
126) Multiple Queries Using MySQLi
127) MySQL Class to ease Database connectivity
128) MySQL Connection Test
129) Mysql date-time converters part II
130) MySQL driver class
131) Mysql escape string
132) MySQL Handler
133) MySQL Report generation in PHP
134) Mysql_affected_rows() returns the number of rows affected by an SQL query involving an INSERT, UPDATE, REPLACE, or DELETE.t
135) Mysql_db_query php
136) Mysql_fetch_array php
137) Mysql_fetch_array-2 php
138) Mysql_fetch_field php
139) Mysql_fetch_row php
140) Mysql_fetch_row() fetches rows
141) Mysql_field_name php
142) Mysql_field_table php
143) Mysql_field_type php
144) Mysql_list_fields php
145) Mysql_list_processes php
146) Mysql_list_tables php
147) Mysql_num_fields php
148) Mysql_num_rows php
149) Mysql_query php
150) Mysql_result php
151) Mysql_result-2 php
152) Mysql_select_db php
153) Mysql_select_db()
154) Mysql_stat php
155) Mysql_tablename php
156) Mysqli_fetch_object php
157) Mysqli_fetch_result php
158) Mysqli_fetch_result-2 php
159) Mysqli_fetch_row php
160) Mysqli_free_result php
161) Mysqli_multi_query php
162) Mysqli_stmt_prepare php
163) Mysqli_store_result php
164) Normalize fields and strings used in where (commands Sql)
165) Number of Rows
166) Odbc_close()
167) Odbc_connect()
168) Odbc_free_result()
169) Odbc_prepare()
170) Odbc_result_all() formats and displays all rows produced by odbc_exec() or odbc_execute()
171) Ok, so heres the deal. This is a simple shout box that can display the comments
172) Opening a Connection and Selecting a Database
173) Opening a SQLite Database
174) Paginating the mySQL data
175) Parameter Binding in MySQLi
176) PHP and MySQL scripting for Muyltiple CheckBoxes
177) PHP code to establish a connection with MySQL
178) PHP4 AND MySQL Authentication
179) PostGreSQL and MySQL 2 in 1 db Manager
180) Print all MySQL status value
181) Print MySQL processes information
182) Reading in Data
183) Recordset Class for MSSQL database
184) Reference columns by name
185) Reference table columns by index
186) Result Binding in Prepared Statements
187) Retrieving and Displaying Results
188) Retrieving_multiple_rows php
189) Script for postgresql to walk through the results limiting the results shown per
190) Select Examples
191) Selecting a Database
192) Sending SQL Queries to a MySQL Database using the mysql_query () function
193) Setting up InnoDB on MySQL and using Transactions Begin
194) Sign the guestbook
195) Simple database class
196) Simple menu system PHP
197) Simple PHP-3 Access Counter (using GD and DBM functions)
198) Simple pipe delimited file export program that downloads to a local machine
199) Simple script to send emails via a html-form to different users
200) SQL Dump to Database
201) Sql_regcase
202) Sql_regcase() function converts each character into a bracketed expression containing two characters
203) SQLite Error Constants
204) Sqlite_array_query php
205) Sqlite_column php
206) Sqlite_create_function php
207) Sqlite_fetch_array php
208) Sqlite_fetch_array-2 php
209) Sqlite_fetch_column_types php
210) Sqlite_fetch_single php
211) Sqlite_field_name php
212) Sqlite_has_more php
213) Sqlite_num_fields php
214) Sqlite_num_rows php
215) Sqlite_query php
216) Sqlite_seek php
217) Store query result in an array
218) Store query result in an associate array
219) Store query result in an Object
220) Storing Information in a Database
221) Storing structured data in a DBM database
222) TAB_STRUCT Class Is supporting Class for the DBXML Class
223) Table and Field Information
224) Table data insert
225) Table-Creation Script
226) This banner rotator is a little bit different from others, the banner will change
227) This function emulates the ASP GetRows function
228) This functions makes it easy to use session-variables known from ASP
229) This is a class with functions that are taken from simple SQL statements
230) This is a database wrapper for PostgreSQL, but can be simply modified
231) This is a function to display a table for Postgres results
232) This is a PHP5 SQLite abstraction class with many usefull functionnalities
233) This is Yet Another Sql Abstraction Library. Include it in your script and
234) This program allows you to upload an ODBC ressource - i.e. an MS-Access
235) This script is a contact form between users of a website
236) This script is meant for drilling through your db
237) This shows how to page thru a resultset in a simple manner
238) Tired to edit forms this simple script will edit or update ANY MySQL database
239) Total number of fields in a table
240) Tracking users and passwords with a DBM database
241) Unbuffered Queries for Large Data Sets
242) Update data record and get the affected rows
243) Update Employee table
244) Upload image file to MySQL as BLOB
245) Use Column name in select statement as the variable name
246) Use for loop to read all query result
247) Use form to add data to database
248) Use mysql_result function to get query result
249) Use mysqli to fetch data from mysql
250) User authentication with php3 and msql
251) Using MySQL with PHP
252) Using mysqli_error() and mysqli_errno()
253) Using PHP variables wherever you want inside SQL queries
254) Using PHPs ODBC functions to interface with MS Access
255) Using sqlite_current() and sqlite_next()
256) Using the mysqli Object-Oriented API
257) Using the mysqli_fetch_array() Function
258) Using the Object-Oriented Syntax in MySQLi
259) Using the sqlite_query() Function
260) Using the sqlite_seek() Function
261) Using timestamp with mysql
262) Using Transactions in MySQLi
263) Various Information
264) When connecting to multiple MySQL servers, a link ID must be generated
265) While loop and mysql_fetch_array() function
266) Yet another random password generator with md5 encryption